*******************************************************************************

******************
* newspaper data *
******************

use "${clean}newspaper_analysis.dta", clear

keep if north == 1 | south == 1

// recoding Alexandria, VA to the South (technically part of DC until 1844)
replace south = 1 if city == "Alexandria"
replace north = 0 if city == "Alexandria"
replace state = "Virginia" if city == "Alexandria"

// dropping DC as a border area
drop if state == "District Of Columbia"

// descriptives
unique pub_id, by(source)
unique docname, by(source)
tab singular source



***************
* speech data *
***************

use "${clean}analysis.dta", clear

keep if north == 1

// dropping DC as a border area
drop if state == "District Of Columbia"

// descriptives
unique bioguide_id if congress >= 32 & congress <= 42
unique bioguide_id if congress >= 43 & congress <= 55
unique bioguide_id if congress >= 32 & congress <= 55

tab singular if congress >= 32 & congress <= 42
tab singular if congress >= 43 & congress <= 55
tab singular if congress >= 32 & congress <= 55
